package org.idea.qiyu.framework.marketing.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.idea.qiyu.framework.marketing.model.MarketingProduct;

import java.util.List;

/**
 * @Author linhao
 * @Date created in 6:34 下午 2021/7/23
 */
@Mapper
public interface MarketingProductMapper {

    @Select("select * from t_marketing_product")
    List<MarketingProduct> selectAll();

    @Select("select * from t_marketing_product where productNo=#{productNo} and validStatus=0 limit 1")
    MarketingProduct selectByProductNo(@Param("productNo") Integer productNo);
}
